Search Results for: "Ruger Hawkeye long range"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='Ruger Hawkeye long range' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 213468 then 1 
 when 214493 then 2 
 when 214066 then 3 
 when 251173 then 4 
 when 252513 then 5 
 when 253810 then 6 
 when 268565 then 7 
 when 253807 then 8 
 when 252413 then 9 
 when 109085 then 10 
 when 252414 then 11 
 when 168707 then 12 
 when 252500 then 13 
 when 220912 then 14 
 when 158240 then 15 
 when 252517 then 16 
 when 252514 then 17 
 when 228208 then 18 
 when 252518 then 19 
 when 248687 then 20 
 when 102040 then 21 
 when 252435 then 22 
 when 252429 then 23 
 when 252503 then 24 
 when 253806 then 25 
 when 247859 then 26 
 when 256074 then 27 
 when 263497 then 28 
 when 252364 then 29 
 when 252505 then 30 
 when 253808 then 31 
 when 248688 then 32 
 when 248685 then 33 
 when 248686 then 34 
 when 209458 then 35 
 when 215125 then 36 
 when 35059 then 37 
 when 116046 then 38 
 when 184551 then 39 
 when 203979 then 40 
 when 205689 then 41 
 when 213283 then 42 
 when 233350 then 43 
 when 144810 then 44 
 when 87203 then 45 
 when 192161 then 46 
 when 192162 then 47 
 when 272765 then 48 
 when 272764 then 49 
 when 207353 then 50 
 when 215124 then 51 
 when 213280 then 52 
 when 281084 then 53 
 when 215128 then 54 
 when 213281 then 55 
 when 246520 then 56 
 when 213287 then 57 
 when 205724 then 58 
 when 213285 then 59 
 when 252512 then 60 
 when 302209 then 61 
 when 203356 then 62 
 when 123918 then 63 
 when 203475 then 64 
 when 215126 then 65 
 when 215129 then 66 
 when 233407 then 67 
 when 233408 then 68 
 when 247760 then 69 
 when 303450 then 70 
 when 233396 then 71 
 when 254964 then 72 
 when 252520 then 73 
 when 213286 then 74 
 when 213433 then 75 
 when 251610 then 76 
 when 289629 then 77 
 when 213432 then 78 
 when 86818 then 79 
 when 202210 then 80 
 when 233714 then 81 
 when 247231 then 82 
 when 252366 then 83 
 when 245283 then 84 
 when 215655 then 85 
 when 212003 then 86 
 when 247232 then 87 
 when 124447 then 88 
 when 42345 then 89 
 when 233453 then 90 
 when 247230 then 91 
 when 252507 then 92 
 when 42336 then 93 
 when 42334 then 94 
 when 306683 then 95 
 when 233712 then 96 
 when 264072 then 97 
 when 261005 then 98 
 when 42332 then 99 
 when 42342 then 100 
 when 282719 then 101 
 when 285542 then 102 
 when 252423 then 103 
 when 252506 then 104 
 when 202893 then 105 
 when 248383 then 106 
 when 252515 then 107 
 when 252437 then 108 
 when 252476 then 109 
 when 252502 then 110 
 when 197490 then 111 
 when 252501 then 112 
 when 252519 then 113 
 when 252504 then 114 
 when 252428 then 115 
 when 82518 then 116 
 when 248425 then 117 
 when 207357 then 118 
 when 276959 then 119 
 when 276964 then 120 
 when 276962 then 121 
 when 251651 then 122 
 when 252436 then 123 
 when 44691 then 124 
 when 207355 then 125 
 when 215134 then 126 
 when 279845 then 127 
 when 207356 then 128 
 when 276958 then 129 
 when 213292 then 130 
 when 215136 then 131 
 when 279149 then 132 
 when 276953 then 133 
 when 233713 then 134 
 when 42347 then 135 
 when 207358 then 136 
 when 205723 then 137 
 when 213434 then 138 
 when 276961 then 139 
 when 276951 then 140 
 when 287531 then 141 
 when 287506 then 142 
 when 213291 then 143 
 when 217362 then 144 
 when 276956 then 145 
 when 287529 then 146 
 when 279844 then 147 
 when 207354 then 148 
 when 213290 then 149 
 when 217360 then 150 
 when 215131 then 151 
 when 276963 then 152 
 when 287530 then 153 
 when 287510 then 154 
 when 86572 then 155 
 when 276957 then 156 
 when 42348 then 157 
 when 217354 then 158 
 when 217359 then 159 
 when 276949 then 160 
 when 289935 then 161 
 when 287528 then 162 
 when 295086 then 163 
 when 42341 then 164 
 when 42346 then 165 
 when 42335 then 166 
 when 199108 then 167 
 when 204301 then 168 
 when 204305 then 169 
 when 217361 then 170 
 when 42322 then 171 
 when 42344 then 172 
 when 204298 then 173 
 when 212002 then 174 
 when 42343 then 175 
 when 123691 then 176 
 when 42323 then 177 
 when 42324 then 178 
 when 42330 then 179 
 when 42331 then 180 
 when 42325 then 181 
 when 204296 then 182 
 when 185592 then 183 
 when 195437 then 184 
 when 12670 then 185 
 when 12704 then 186 
 when 22750 then 187 
 when 10992 then 188 
 when 202875 then 189 
 when 143177 then 190 
 when 198451 then 191 
 when 209963 then 192 
 when 31917 then 193 
 when 87466 then 194 
 when 256820 then 195 
 when 218466 then 196 
 when 124555 then 197 
 when 305618 then 198 
 when 154889 then 199 
 when 10989 then 200 
 when 168535 then 201 
 when 254418 then 202 
 when 10990 then 203 
 when 67679 then 204 
 when 99243 then 205 
 when 205196 then 206 
 when 264985 then 207 
 when 205501 then 208 
 when 247804 then 209 
 when 202882 then 210 
 when 24230 then 211 
 when 86515 then 212 
 when 260872 then 213 
 when 307408 then 214 
 when 71121 then 215 
 when 189652 then 216 
 when 266352 then 217 
 when 289754 then 218 
 when 113615 then 219 
 when 61954 then 220 
 when 267842 then 221 
 when 298060 then 222 
 when 189422 then 223 
 when 198943 then 224 
 when 198937 then 225 
 when 198942 then 226 
 when 202876 then 227 
 when 202883 then 228 
 when 198944 then 229 
 when 198938 then 230 
 when 202877 then 231 
 when 189844 then 232 
 when 192759 then 233 
 when 288117 then 234 
 when 94495 then 235 
 when 198941 then 236 
 when 202881 then 237 
 when 154892 then 238 
 when 101837 then 239 
 when 267888 then 240 
 when 267855 then 241 
 when 267871 then 242 
 when 267421 then 243 
 when 202857 then 244 
 when 296799 then 245 
 when 191477 then 246 
 when 188443 then 247 
 when 135169 then 248 
 when 179239 then 249 
 when 268298 then 250 
 when 225274 then 251 
 when 254419 then 252 
 when 100304 then 253 
 when 253689 then 254 
 when 304435 then 255 
 when 304434 then 256 
 when 213763 then 257 
 when 267184 then 258 
 when 110469 then 259 
 when 189420 then 260 
 when 222398 then 261 
 when 191562 then 262 
 when 189647 then 263 
 when 198940 then 264 
 when 198939 then 265 
 when 195471 then 266 
 when 202880 then 267 
 when 197025 then 268 
 when 197028 then 269 
 when 189833 then 270 
 when 156524 then 271 
 when 256000 then 272 
 when 179770 then 273 
 when 134551 then 274 
 when 304433 then 275 
 when 189128 then 276 
 when 189651 then 277 
 when 262361 then 278 
 when 172331 then 279 
 when 7173 then 280 
 when 204231 then 281 
 when 191884 then 282 
 when 191885 then 283 
 when 225767 then 284 
 when 202879 then 285 
 when 73085 then 286 
 when 134605 then 287 
 when 220142 then 288 
 when 51724 then 289 
 when 222395 then 290 
 when 100863 then 291 
 when 222401 then 292 
 when 289556 then 293 
 when 305143 then 294 
 when 222396 then 295 
 when 220139 then 296 
 when 197029 then 297 
 when 60327 then 298 
 when 269083 then 299 
 when 247915 then 300 
 when 51723 then 301 
 when 51722 then 302 
 when 97929 then 303 
 when 222394 then 304 
 when 134541 then 305 
 when 307374 then 306 
 when 258 then 307 
 when 256814 then 308 
 when 70755 then 309 
 when 189831 then 310 
 when 197033 then 311 
 when 197032 then 312 
 when 74568 then 313 
 when 307373 then 314 
 when 287586 then 315 
 when 191578 then 316 
 when 216142 then 317 
 when 135334 then 318 
 when 7017 then 319 
 when 198582 then 320 
 when 197859 then 321 
 when 222014 then 322 
 when 192175 then 323 
 when 209984 then 324 
 when 188453 then 325 
 when 13394 then 326 
 when 70489 then 327 
 when 282817 then 328 
 when 282816 then 329 
 when 297065 then 330 
 when 282815 then 331 
 when 205600 then 332 
 when 61367 then 333 
 when 216389 then 334 
 when 136685 then 335 
 when 188442 then 336 
 when 40363 then 337 
 when 163904 then 338 
 when 192176 then 339 
 when 203888 then 340 
 when 272767 then 341 
 when 255679 then 342 
 when 250503 then 343 
 when 13397 then 344 
 when 13396 then 345 
 when 205599 then 346 
 when 1222 then 347 
 when 222933 then 348 
 when 215819 then 349 
 when 296330 then 350 
 when 296329 then 351 
 when 103596 then 352 
 when 268274 then 353 
 when 251210 then 354 
 when 182063 then 355 
 when 216915 then 356 
 when 216918 then 357 
 when 216919 then 358 
 when 216916 then 359 
 when 220141 then 360 
 when 40384 then 361 
 when 188444 then 362 
 when 220443 then 363 
 when 248900 then 364 
 when 278396 then 365 
 when 165374 then 366 
 when 189648 then 367 
 when 185609 then 368 
 when 267183 then 369 
 when 282204 then 370 
 when 284635 then 371 
 when 295073 then 372 
 when 154815 then 373 
 when 168706 then 374 
 when 191744 then 375 
 when 219777 then 376 
 when 268638 then 377 
 when 216542 then 378 
 when 154814 then 379 
 when 154808 then 380 
 when 249939 then 381 
 when 251229 then 382 
 when 267924 then 383 
 when 262843 then 384 
 when 281728 then 385 
 when 225685 then 386 
 when 145418 then 387 
 when 220140 then 388 
 when 35057 then 389 
 when 143198 then 390 
 when 168257 then 391 
 when 189653 then 392 
 when 189654 then 393 
 when 195475 then 394 
 when 210467 then 395 
 when 198799 then 396 
 when 249745 then 397 
 when 255964 then 398 
 when 267981 then 399 
 when 146858 then 400 
 when 222595 then 401 
 when 130257 then 402 
 when 27952 then 403 
 when 133433 then 404 
 when 255251 then 405 
 when 266943 then 406 
 when 267980 then 407 
 when 267103 then 408 
 when 89930 then 409 
 when 215428 then 410 
 when 296935 then 411 
 when 296934 then 412 
 when 296933 then 413 
 when 205745 then 414 
 when 142844 then 415 
 when 137064 then 416 
 when 137062 then 417 
 when 202120 then 418 
 when 104706 then 419 
 when 104561 then 420 
 when 168256 then 421 
 when 249960 then 422 
 when 250658 then 423 
 when 254870 then 424 
 when 251033 then 425 
 when 266762 then 426 
 when 263790 then 427 
 when 267208 then 428 
 when 225985 then 429 
 when 287831 then 430 
 when 168258 then 431 
 when 309879 then 432 
 when 202119 then 433 
 when 27953 then 434 
 when 204264 then 435 
 when 245026 then 436 
 when 261077 then 437 
 when 262848 then 438 
 when 272741 then 439 
 when 262845 then 440 
 when 288346 then 441 
 when 133931 then 442 
 when 103981 then 443 
 when 303300 then 444 
 when 298540 then 445 
 when 273804 then 446 
 when 303302 then 447 
 when 197894 then 448 
 when 137066 then 449 
 when 137068 then 450 
 when 232629 then 451 
 when 202116 then 452 
 when 195469 then 453 
 when 250346 then 454 
 when 254313 then 455 
 when 268719 then 456 
 when 262841 then 457 
 when 277175 then 458 
 when 281640 then 459 
 when 282977 then 460 
 when 296932 then 461 
 when 191761 then 462 
 when 137071 then 463 
 when 191771 then 464 
 when 122263 then 465 
 when 147963 then 466 
 when 205746 then 467 
 when 245028 then 468 
 when 268721 then 469 
 when 262874 then 470 
 when 207503 then 471 
 when 245027 then 472 
 when 135034 then 473 
 when 105803 then 474 
 when 135426 then 475 
 when 135279 then 476 
 when 105795 then 477 
 when 207501 then 478 
 when 262844 then 479 
 when 218084 then 480 
 when 283521 then 481 
 when 123535 then 482 
 when 207628 then 483 
 when 249643 then 484 
 when 169896 then 485 
 when 192359 then 486 
 when 251803 then 487 
 when 136823 then 488 
 when 105797 then 489 
 when 90618 then 490 
 when 135281 then 491 
 when 102364 then 492 
 when 219788 then 493 
 when 250551 then 494 
 when 219973 then 495 
 when 217481 then 496 
 when 290099 then 497 
 when 196173 then 498 
 when 219660 then 499 
 when 285249 then 500 
 when 90922 then 501 
 when 118525 then 502 
 when 212098 then 503 
 when 76685 then 504 
 when 205406 then 505 
 when 76683 then 506 
 when 283487 then 507 
 when 189845 then 508 
 when 205011 then 509 
 when 152458 then 510 
 when 246117 then 511 
 when 219796 then 512 
 when 282366 then 513 
 when 255663 then 514 
 when 255678 then 515 
 when 270878 then 516 
 when 263677 then 517 
 when 270877 then 518 
 when 254581 then 519 
 when 288490 then 520 
 when 189826 then 521 
 when 272735 then 522 
 when 277707 then 523 
 when 277761 then 524 
 when 282364 then 525 
 when 57199 then 526 
 when 282365 then 527 
 when 120388 then 528 
 when 270224 then 529 
 when 270237 then 530 
 when 254583 then 531 
 when 122332 then 532 
 when 251339 then 533 
 when 289325 then 534 
 when 308227 then 535 
 when 217898 then 536 
 when 270890 then 537 
 when 189846 then 538 
 when 247803 then 539 
 when 247558 then 540 
 when 285384 then 541 
 when 196637 then 542 
 when 249926 then 543 
 when 247771 then 544 
 when 29570 then 545 
 when 256684 then 546 
 when 267874 then 547 
 when 290520 then 548 
 when 290515 then 549 
 when 9150 then 550 
 when 292676 then 551 
 when 249560 then 552 
 when 203906 then 553 
 when 202501 then 554 
 when 13395 then 555 
 when 254065 then 556 
 when 289375 then 557 
 when 289155 then 558 
 when 252431 then 559 
 when 24646 then 560 
 when 213589 then 561 
 when 252896 then 562 
 when 263732 then 563 
 when 270894 then 564 
 when 307410 then 565 
 when 69631 then 566 
 when 165498 then 567 
 when 249009 then 568 
 when 247531 then 569 
 when 283224 then 570 
 when 289153 then 571 
 when 24667 then 572 
 when 84712 then 573 
 when 99972 then 574 
 when 24742 then 575 
 when 44782 then 576 
 when 68534 then 577 
 when 247202 then 578 
 when 281121 then 579 
 when 289694 then 580 
 when 287585 then 581 
 when 289125 then 582 
 when 247560 then 583 
 when 307685 then 584 
 when 24665 then 585 
 when 24666 then 586 
 when 24517 then 587 
 when 205075 then 588 
 when 301106 then 589 
 when 261105 then 590 
 when 307411 then 591 
 when 24698 then 592 
 when 273498 then 593 
 when 46340 then 594 
 when 252472 then 595 
 when 168369 then 596 
 when 285447 then 597 
 when 255690 then 598 
 when 43039 then 599 
 when 307908 then 600 
 when 298841 then 601 
 when 41470 then 602 
 when 188660 then 603 
 when 176399 then 604 
 when 135272 then 605 
 when 116011 then 606 
 when 252455 then 607 
 when 252344 then 608 
 when 252002 then 609 
 when 68533 then 610 
 when 192799 then 611 
 when 283815 then 612 
 when 9151 then 613 
 when 289446 then 614 
 when 304942 then 615 
 when 247011 then 616 
 when 248207 then 617 
 when 274086 then 618 
 when 277489 then 619 
 when 43040 then 620 
 when 130232 then 621 
 when 122979 then 622 
 when 116010 then 623 
 when 116012 then 624 
 when 168352 then 625 
 when 202108 then 626 
 when 218419 then 627 
 when 252442 then 628 
 when 252468 then 629 
 when 252420 then 630 
 when 252516 then 631 
 when 130210 then 632 
 when 203915 then 633 
 when 204290 then 634 
 when 247436 then 635 
 when 202888 then 636 
 when 307412 then 637 
 when 130209 then 638 
 when 153294 then 639 
 when 192961 then 640 
 when 202302 then 641 
 when 152457 then 642 
 when 152459 then 643 
 when 215181 then 644 
 when 214266 then 645 
 when 246083 then 646 
 when 250584 then 647 
 when 252570 then 648 
 when 219839 then 649 
 when 46369 then 650 
 when 214267 then 651 
 when 202351 then 652 
 when 19322 then 653 
 when 111453 then 654 
 when 132532 then 655 
 when 44765 then 656 
 when 125598 then 657 
 when 191746 then 658 
 when 114665 then 659 
 when 179662 then 660 
 when 191777 then 661 
 when 218420 then 662 
 when 252444 then 663 
 when 252416 then 664 
 when 204623 then 665 
 when 44761 then 666 
 when 211780 then 667 
 when 252422 then 668 
 when 252427 then 669 
 when 189976 then 670 
 when 207023 then 671 
 when 215618 then 672 
 when 232432 then 673 
 when 249935 then 674 
 when 278985 then 675 
 when 216567 then 676 
 when 117226 then 677 
 when 249292 then 678 
 when 268344 then 679 
 when 65130 then 680 
 when 281088 then 681 
 when 23377 then 682 
 when 197087 then 683 
 when 289834 then 684 
 when 284841 then 685 
 when 296281 then 686 
 when 100321 then 687 
 when 143336 then 688 
 when 145603 then 689 
 when 44625 then 690 
 when 44758 then 691 
 when 182235 then 692 
 when 168394 then 693 
 when 192485 then 694 
 when 195460 then 695 
 when 192368 then 696 
 when 152460 then 697 
 when 152461 then 698 
 when 143120 then 699 
 when 152323 then 700 
 when 152325 then 701 
 when 158599 then 702 
 when 202080 then 703 
 when 204886 then 704 
 when 211779 then 705 
 when 213900 then 706 
 when 211296 then 707 
 when 217881 then 708 
 when 228207 then 709 
 when 78204 then 710 
 when 245408 then 711 
 when 252480 then 712 
 when 267293 then 713 
 when 274156 then 714 
 when 123666 then 715 
 when 44760 then 716 
 when 118963 then 717 
 when 262136 then 718 
 when 95836 then 719 
 when 111461 then 720 
 when 44674 then 721 
 when 179690 then 722 
 when 188661 then 723 
 when 203904 then 724 
 when 152324 then 725 
 when 159567 then 726 
 when 155428 then 727 
 when 198293 then 728 
 when 217714 then 729 
 when 213912 then 730 
 when 214265 then 731 
 when 214095 then 732 
 when 225680 then 733 
 when 251682 then 734 
 when 255511 then 735 
 when 253006 then 736 
 when 252425 then 737 
 when 252453 then 738 
 when 252510 then 739 
 when 262280 then 740 
 when 44732 then 741 
 when 169095 then 742 
 when 196889 then 743 
 when 124526 then 744 
 when 256340 then 745 
 when 122291 then 746 
 when 129869 then 747 
 when 99947 then 748 
 when 99665 then 749 
 when 141672 then 750 
 when 157975 then 751 
 when 178580 then 752 
 when 184466 then 753 
 when 67787 then 754 
 when 199114 then 755 
 when 196785 then 756 
 when 199112 then 757 
 when 201633 then 758 
 when 192370 then 759 
 when 203909 then 760 
 when 152320 then 761 
 when 203914 then 762 
 when 156460 then 763 
 when 203897 then 764 
 when 211307 then 765 
 when 218558 then 766 
 when 147047 then 767 
 when 219604 then 768 
 when 222047 then 769 
 when 245075 then 770 
 when 252363 then 771 
 when 253465 then 772 
 when 264889 then 773 
 when 280982 then 774 
 when 286885 then 775 
 when 122511 then 776 
 when 182368 then 777 
 when 152322 then 778 
 when 182084 then 779 
 when 205816 then 780 
 when 215778 then 781 
 when 138785 then 782 
 when 252434 then 783 
 when 252508 then 784 
 when 254303 then 785 
 when 114630 then 786 
 when 44680 then 787 
 when 44677 then 788 
 when 71510 then 789 
 when 152464 then 790 
 when 122408 then 791 
 when 84992 then 792 
 when 175816 then 793 
 when 169096 then 794 
 when 179655 then 795 
 when 199015 then 796 
 when 63789 then 797 
 when 193586 then 798 
 when 203908 then 799 
 when 44757 then 800 
 when 207535 then 801 
 when 213796 then 802 
 when 44632 then 803 
 when 246100 then 804 
 when 228579 then 805 
 when 245575 then 806 
 when 193528 then 807 
 when 254492 then 808 
 when 128641 then 809 
 when 252343 then 810 
 when 273338 then 811 
 when 274428 then 812 
 when 152571 then 813 
 when 152398 then 814 
 when 159150 then 815 
 when 184467 then 816 
 when 205221 then 817 
 when 218055 then 818 
 when 164331 then 819 
 when 286881 then 820 
 when 213351 then 821 
 when 282120 then 822 
 when 285003 then 823 
 when 303298 then 824 
 when 305502 then 825 
 when 134036 then 826 
 when 220122 then 827 
 when 218198 then 828 
 when 249701 then 829 
 when 260448 then 830 
 when 267738 then 831 
 when 267710 then 832 
 when 117774 then 833 
 when 281103 then 834 
 when 285444 then 835 
 when 285226 then 836 
 when 283255 then 837 
 when 283265 then 838 
 when 285243 then 839 
 when 285366 then 840 
 when 216680 then 841 
 when 294751 then 842 
 when 298930 then 843 
 when 298407 then 844 
 when 182338 then 845 
 when 211583 then 846 
 when 291705 then 847 
 when 291862 then 848 
 when 298405 then 849 
 when 125690 then 850 
 when 81239 then 851 
 when 126124 then 852 
 when 44844 then 853 
 when 44833 then 854 
 when 130260 then 855 
 when 148326 then 856 
 when 154963 then 857 
 when 176527 then 858 
 when 181920 then 859 
 when 197510 then 860 
 when 199002 then 861 
 when 202078 then 862 
 when 201900 then 863 
 when 205229 then 864 
 when 214050 then 865 
 when 218054 then 866 
 when 150965 then 867 
 when 217713 then 868 
 when 221999 then 869 
 when 220760 then 870 
 when 263431 then 871 
 when 267202 then 872 
 when 44776 then 873 
 when 268578 then 874 
 when 279058 then 875 
 when 287608 then 876 
 when 44835 then 877 
 when 44706 then 878 
 when 142953 then 879 
 when 117505 then 880 
 when 168036 then 881 
 when 192948 then 882 
 when 44633 then 883 
 when 215281 then 884 
 when 252351 then 885 
 when 252355 then 886 
 when 264586 then 887 
 when 103201 then 888 
 when 44837 then 889 
 when 122404 then 890 
 when 122415 then 891 
 when 133124 then 892 
 when 113863 then 893 
 when 143739 then 894 
 when 92057 then 895 
 when 157849 then 896 
 when 44631 then 897 
 when 181921 then 898 
 when 191785 then 899 
 when 192460 then 900 
 when 197425 then 901 
 when 194286 then 902 
 when 198742 then 903 
 when 200103 then 904 
 when 145094 then 905 
 when 207336 then 906 
 when 203895 then 907 
 when 206284 then 908 
 when 44626 then 909 
 when 219752 then 910 
 when 219719 then 911 
 when 245572 then 912 
 when 246718 then 913 
 when 246097 then 914 
 when 252461 then 915 
 when 255627 then 916 
 when 254546 then 917 
 when 264532 then 918 
 when 289168 then 919 
 when 291268 then 920 
 when 97312 then 921 
 when 44686 then 922 
 when 126519 then 923 
 when 163876 then 924 
 when 169093 then 925 
 when 192488 then 926 
 when 195559 then 927 
 when 198816 then 928 
 when 199492 then 929 
 when 254256 then 930 
 when 257303 then 931 
 when 134004 then 932 
 when 128639 then 933 
 when 134006 then 934 
 when 44726 then 935 
 when 110298 then 936 
 when 122763 then 937 
 when 87677 then 938 
 when 44836 then 939 
 when 44845 then 940 
 when 110809 then 941 
 when 96374 then 942 
 when 126586 then 943 
 when 143717 then 944 
 when 107584 then 945 
 when 168708 then 946 
 when 193946 then 947 
 when 196898 then 948 
 when 225938 then 949 
 when 245074 then 950 
 when 250144 then 951 
 when 247067 then 952 
 when 252365 then 953 
 when 266214 then 954 
 when 134114 then 955 
 when 44661 then 956 
 when 214358 then 957 
 when 225681 then 958 
 when 225670 then 959 
 when 245407 then 960 
 when 202886 then 961 
 when 202892 then 962 
 when 249456 then 963 
 when 255252 then 964 
 when 266737 then 965 
 when 282867 then 966 
 when 284692 then 967 
 when 297285 then 968 
 when 253440 then 969 
 when 225764 then 970 
 when 123402 then 971 
 when 179783 then 972 
 when 72333 then 973 
 when 220112 then 974 
 when 250022 then 975 
 when 289828 then 976 
 when 285445 then 977 
 when 294675 then 978 
 when 291854 then 979 
 when 297755 then 980 
 when 197111 then 981 
 when 123906 then 982 
 when 130015 then 983 
 when 100239 then 984 
 when 125792 then 985 
 when 94091 then 986 
 when 136937 then 987 
 when 137485 then 988 
 when 152377 then 989 
 when 163726 then 990 
 when 170446 then 991 
 when 188884 then 992 
 when 198817 then 993 
 when 199950 then 994 
 when 202785 then 995 
 when 201641 then 996 
 when 201902 then 997 
 when 205079 then 998 
 when 208654 then 999 
 when 211405 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (213468,214493,214066,251173,252513,253810,268565,253807,252413,109085,252414,168707,252500,220912,158240,252517,252514,228208,252518,248687,102040,252435,252429,252503,253806,247859,256074,263497,252364,252505,253808,248688,248685,248686,209458,215125,35059,116046,184551,203979,205689,213283,233350,144810,87203,192161,192162,272765,272764,207353,215124,213280,281084,215128,213281,246520,213287,205724,213285,252512,302209,203356,123918,203475,215126,215129,233407,233408,247760,303450,233396,254964,252520,213286,213433,251610,289629,213432,86818,202210,233714,247231,252366,245283,215655,212003,247232,124447,42345,233453,247230,252507,42336,42334,306683,233712,264072,261005,42332,42342,282719,285542,252423,252506,202893,248383,252515,252437,252476,252502,197490,252501,252519,252504,252428,82518,248425,207357,276959,276964,276962,251651,252436,44691,207355,215134,279845,207356,276958,213292,215136,279149,276953,233713,42347,207358,205723,213434,276961,276951,287531,287506,213291,217362,276956,287529,279844,207354,213290,217360,215131,276963,287530,287510,86572,276957,42348,217354,217359,276949,289935,287528,295086,42341,42346,42335,199108,204301,204305,217361,42322,42344,204298,212002,42343,123691,42323,42324,42330,42331,42325,204296,185592,195437,12670,12704,22750,10992,202875,143177,198451,209963,31917,87466,256820,218466,124555,305618,154889,10989,168535,254418,10990,67679,99243,205196,264985,205501,247804,202882,24230,86515,260872,307408,71121,189652,266352,289754,113615,61954,267842,298060,189422,198943,198937,198942,202876,202883,198944,198938,202877,189844,192759,288117,94495,198941,202881,154892,101837,267888,267855,267871,267421,202857,296799,191477,188443,135169,179239,268298,225274,254419,100304,253689,304435,304434,213763,267184,110469,189420,222398,191562,189647,198940,198939,195471,202880,197025,197028,189833,156524,256000,179770,134551,304433,189128,189651,262361,172331,7173,204231,191884,191885,225767,202879,73085,134605,220142,51724,222395,100863,222401,289556,305143,222396,220139,197029,60327,269083,247915,51723,51722,97929,222394,134541,307374,258,256814,70755,189831,197033,197032,74568,307373,287586,191578,216142,135334,7017,198582,197859,222014,192175,209984,188453,13394,70489,282817,282816,297065,282815,205600,61367,216389,136685,188442,40363,163904,192176,203888,272767,255679,250503,13397,13396,205599,1222,222933,215819,296330,296329,103596,268274,251210,182063,216915,216918,216919,216916,220141,40384,188444,220443,248900,278396,165374,189648,185609,267183,282204,284635,295073,154815,168706,191744,219777,268638,216542,154814,154808,249939,251229,267924,262843,281728,225685,145418,220140,35057,143198,168257,189653,189654,195475,210467,198799,249745,255964,267981,146858,222595,130257,27952,133433,255251,266943,267980,267103,89930,215428,296935,296934,296933,205745,142844,137064,137062,202120,104706,104561,168256,249960,250658,254870,251033,266762,263790,267208,225985,287831,168258,309879,202119,27953,204264,245026,261077,262848,272741,262845,288346,133931,103981,303300,298540,273804,303302,197894,137066,137068,232629,202116,195469,250346,254313,268719,262841,277175,281640,282977,296932,191761,137071,191771,122263,147963,205746,245028,268721,262874,207503,245027,135034,105803,135426,135279,105795,207501,262844,218084,283521,123535,207628,249643,169896,192359,251803,136823,105797,90618,135281,102364,219788,250551,219973,217481,290099,196173,219660,285249,90922,118525,212098,76685,205406,76683,283487,189845,205011,152458,246117,219796,282366,255663,255678,270878,263677,270877,254581,288490,189826,272735,277707,277761,282364,57199,282365,120388,270224,270237,254583,122332,251339,289325,308227,217898,270890,189846,247803,247558,285384,196637,249926,247771,29570,256684,267874,290520,290515,9150,292676,249560,203906,202501,13395,254065,289375,289155,252431,24646,213589,252896,263732,270894,307410,69631,165498,249009,247531,283224,289153,24667,84712,99972,24742,44782,68534,247202,281121,289694,287585,289125,247560,307685,24665,24666,24517,205075,301106,261105,307411,24698,273498,46340,252472,168369,285447,255690,43039,307908,298841,41470,188660,176399,135272,116011,252455,252344,252002,68533,192799,283815,9151,289446,304942,247011,248207,274086,277489,43040,130232,122979,116010,116012,168352,202108,218419,252442,252468,252420,252516,130210,203915,204290,247436,202888,307412,130209,153294,192961,202302,152457,152459,215181,214266,246083,250584,252570,219839,46369,214267,202351,19322,111453,132532,44765,125598,191746,114665,179662,191777,218420,252444,252416,204623,44761,211780,252422,252427,189976,207023,215618,232432,249935,278985,216567,117226,249292,268344,65130,281088,23377,197087,289834,284841,296281,100321,143336,145603,44625,44758,182235,168394,192485,195460,192368,152460,152461,143120,152323,152325,158599,202080,204886,211779,213900,211296,217881,228207,78204,245408,252480,267293,274156,123666,44760,118963,262136,95836,111461,44674,179690,188661,203904,152324,159567,155428,198293,217714,213912,214265,214095,225680,251682,255511,253006,252425,252453,252510,262280,44732,169095,196889,124526,256340,122291,129869,99947,99665,141672,157975,178580,184466,67787,199114,196785,199112,201633,192370,203909,152320,203914,156460,203897,211307,218558,147047,219604,222047,245075,252363,253465,264889,280982,286885,122511,182368,152322,182084,205816,215778,138785,252434,252508,254303,114630,44680,44677,71510,152464,122408,84992,175816,169096,179655,199015,63789,193586,203908,44757,207535,213796,44632,246100,228579,245575,193528,254492,128641,252343,273338,274428,152571,152398,159150,184467,205221,218055,164331,286881,213351,282120,285003,303298,305502,134036,220122,218198,249701,260448,267738,267710,117774,281103,285444,285226,283255,283265,285243,285366,216680,294751,298930,298407,182338,211583,291705,291862,298405,125690,81239,126124,44844,44833,130260,148326,154963,176527,181920,197510,199002,202078,201900,205229,214050,218054,150965,217713,221999,220760,263431,267202,44776,268578,279058,287608,44835,44706,142953,117505,168036,192948,44633,215281,252351,252355,264586,103201,44837,122404,122415,133124,113863,143739,92057,157849,44631,181921,191785,192460,197425,194286,198742,200103,145094,207336,203895,206284,44626,219752,219719,245572,246718,246097,252461,255627,254546,264532,289168,291268,97312,44686,126519,163876,169093,192488,195559,198816,199492,254256,257303,134004,128639,134006,44726,110298,122763,87677,44836,44845,110809,96374,126586,143717,107584,168708,193946,196898,225938,245074,250144,247067,252365,266214,134114,44661,214358,225681,225670,245407,202886,202892,249456,255252,266737,282867,284692,297285,253440,225764,123402,179783,72333,220112,250022,289828,285445,294675,291854,297755,197111,123906,130015,100239,125792,94091,136937,137485,152377,163726,170446,188884,198817,199950,202785,201641,201902,205079,208654,211405)
 
 
  and ltrim(rtrim(lower(a.dept))) = 'firearm accessories'
 
  and ltrim(rtrim(lower(a.brand))) = 'birchwood casey'
 
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =191562 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=191562 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 191562 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 191562 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:21:05' and
end_date >= 'May 20, 2024 15:21:05'
and store_id=10 and style_id=191562

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 191562 
and (a.start_date<= 'May 20, 2024 15:21:05' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:21:05'
order by a.promo_id desc

Select distinct * from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='Gun Storage' and subtyp_1='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=191562  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=191562
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =7017 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=7017 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 7017 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 7017 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 15:21:05' and
end_date >= 'May 20, 2024 15:21:05'
and store_id=10 and style_id=7017

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 7017 
and (a.start_date<= 'May 20, 2024 15:21:05' or a.active = 1)
and a.end_date >= 'May 20, 2024 15:21:05'
order by a.promo_id desc

Select distinct * from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='Targets' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='Targets' and subtyp_1='Target Stands & Accessories' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=7017  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=7017
												and status='A' 
												and site = 'sportsman'

SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =134605 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END

select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=134605 and e.store_id =10 group by a.style_id order by a.style_id

select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 134605 and e.store_id = 10 
											group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 134605 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')

Select distinct * from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

Select web_url, typ from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='Targets' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Firearm Accessories' and typ='Targets' and subtyp_1='Paper Targets' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_product_reviews 
												where style_id=134605  
												and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=134605
												and status='A' 
												and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/Ruger%20Hawkeye%20long%20range/brand/birchwood-casey/dept/firearm%20accessories
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/Ruger Hawkeye long range/brand/birchwood-casey/dept/firearm accessories
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=14657
cftoken=e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90
hitcount=1
lastvisit={ts '2024-05-20 15:21:04'}
timecreated={ts '2024-05-20 15:21:04'}
urltoken=CFID=14657&CFTOKEN=e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90

Cookie Variables:
CFID=14657
CFTOKEN=e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
USERNAME=
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
KWORD=Ruger Hawkeye long range
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=14657
cftoken=e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_14657_e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90
strarray=Array (0)
urltoken=CFID=14657&CFTOKEN=e6e65c8d2719756a-EA809C66-E4B4-0A93-7C6B3C269EAACA90

URL Parameters:
CLEARANCE=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=birchwood-casey
dept=firearm accessories
kword=Ruger Hawkeye long range